There was an error executing the SQL Query:-

SELECT dbo.Distance(LATITUDE, LONGITUDE, 0, 0) AS DIST, * FROM NA_PROPERTY WHERE TYPE = 'RESID' AND BEDROOMS >= '0' AND PRICE BETWEEN '0' AND '999999999' AND STATUS <> 'ARCHIVE' ORDER BY PRICE%20ASC;


Error was

The data types float and int are incompatible in the modulo operator.